Overview

Dataset info

Number of variables42
Number of observations484
Missing cells8247 (40.6%)
Duplicate rows0 (0.0%)
Total size in memory158.9 KiB
Average record size in memory336.2 B

Variables types

Numeric15
Categorical14
Boolean0
Date0
URL0
Text (Unique)1
Rejected12
Unsupported0

Warnings

Cold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_Addition_End_DT has a high cardinality: 450 distinct values Warning
Cold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_Addition_End_DT has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_Amount has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_Concentration has constant value "nan" Rejected
Cold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilStirringDuration(min) has constant value "nan" Rejected
Cold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilStirringDurationTxT has 255 (52.7%) missing values Missing
Cold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilSuspTemp(°C) has 475 (98.1%) missing values Missing
Cold_Frac.7-FST_Filtration.Aerosil_Addition.Extract_Aging_(min)(min) has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Aerosil_Addition.ExtractDuration(h) has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Amount_of_Celpure has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Calcs.AerosilAmount/CPPWt has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Calcs.AerosilMixDur(hours) is highly correlated with Cold_Frac.7-FST_Filtration.Aerosil_Addition.Extract_Aging_(min)(min) (ρ = 1) Rejected
Cold_Frac.7-FST_Filtration.Calcs.CelpureAmount/CPPWt has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Calcs.ExtractDur(hours) has constant value "nan" Rejected
Cold_Frac.7-FST_Filtration.Calcs.FRII+III_ExtractFiltrateStepRecovery is highly correlated with Cold_Frac.7-FST_Filtration.Calcs.AerosilAmount/CPPWt (ρ = 0.9530183949) Rejected
Cold_Frac.7-FST_Filtration.Calcs.FRII+III_ExtractPasteRecovery has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Celpure_Addition_Duration has 475 (98.1%) missing values Missing
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.Celpure_Addition_End_Time has 475 (98.1%) missing values Missing
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.Celpure_Addition_Start_Time has 475 (98.1%) missing values Missing
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.End_of_Aerosil_Add_to_Start_of_Filt is highly correlated with Cold_Frac.7-FST_Filtration.Calcs.AerosilMixDur(hours) (ρ = 1) Rejected
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.End_of_Aerosil_Add_to_Start_of_PreCond is highly correlated with Cold_Frac.7-FST_Filtration.Dates_for_Calcs.End_of_Aerosil_Add_to_Start_of_Filt (ρ = 0.9224255422) Rejected
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_Aerosil_ADD_End has a high cardinality: 450 distinct values Warning
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_Aerosil_ADD_End has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_FILT_End has a high cardinality: 450 distinct values Warning
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_FILT_End has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_FILT_Start has a high cardinality: 450 distinct values Warning
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_FILT_Start has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_PRECOND_Start has a high cardinality: 450 distinct values Warning
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_PRECOND_Start has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_STIR_Start has constant value "nan" Rejected
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.Ext_Stir_Start_to_End_of_Aerosil_Add has constant value "nan" Rejected
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.Filtration_End_Time has 475 (98.1%) missing values Missing
Cold_Frac.7-FST_Filtration.Dates_for_Calcs.Filtration_Start_Time has 475 (98.1%) missing values Missing
Cold_Frac.7-FST_Filtration.FilterPressID has constant value "nan" Rejected
Cold_Frac.7-FST_Filtration.Filtrate_Amount(L) has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Filtration_Duration has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.FR_II+III_ExtractPasteWeight(kg) has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.Frac_II_+_III_Extract_Pre_Aerosil_Delivery_Sending_Tank_Temperature_during_Filtration has 475 (98.1%) missing values Missing
Cold_Frac.7-FST_Filtration.PostWashEndDT has a high cardinality: 450 distinct values Warning
Cold_Frac.7-FST_Filtration.PostWashEndDT has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.PPTG_Suspension_Post_Aging_Sending_Tank_Temperature_during_Filtration has 475 (98.1%) missing values Missing
Cold_Frac.7-FST_Filtration.Sampling.IGG_Content(mg/mL) has constant value "nan" Rejected
Cold_Frac.7-FST_Filtration.Sampling.Tprotein(mg/mL) has 34 (7.0%) missing values Missing
Cold_Frac.7-FST_Filtration.StartDT has a high cardinality: 450 distinct values Warning
Cold_Frac.7-FST_Filtration.StartDT has 35 (7.2%) missing values Missing
Cold_Frac.7-FST_Filtration.SuspensionWeight is highly correlated with Cold_Frac.7-FST_Filtration.Filtrate_Amount(L) (ρ = 0.9745320981) Rejected
Parameter_Set_Date only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
Parameter_Set_Date has a high cardinality: 266 distinct values Warning
Unnamed_1 only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
Unnamed_1 has a high cardinality: 266 distinct values Warning

Variables

Cold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_Addition_End_DT
Categorical

Distinct count450
Unique (%)93.0%
Missing (%)7.2%
Missing (n)35
29-Aug-2019 05:49:25 PM
 
1
20-May-2019 02:12:25 PM
 
1
28-Mar-2019 01:06:10 AM
 
1
Other values (446)
446
(Missing)
 
35
ValueCountFrequency (%) 
29-Aug-2019 05:49:25 PM 1 0.2%
 
20-May-2019 02:12:25 PM 1 0.2%
 
28-Mar-2019 01:06:10 AM 1 0.2%
 
29-Sep-2019 06:10:46 AM 1 0.2%
 
27-Jun-2019 09:21:17 PM 1 0.2%
 
25-Aug-2019 05:12:20 PM 1 0.2%
 
19-Apr-2019 02:23:55 PM 1 0.2%
 
16-Feb-2019 03:47:12 AM 1 0.2%
 
12-Mar-2019 01:46:40 PM 1 0.2%
 
17-Apr-2019 02:57:12 PM 1 0.2%
 
Other values (439) 439 90.7%
 
(Missing) 35 7.2%
 
Max length23
Mean length21.55371901
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_Amount
Numeric

Distinct count18
Unique (%)3.7%
Missing (%)7.2%
Missing (n)35
Infinite (%)0.0%
Infinite (n)0
Mean17.35233853
Minimum16.3
Maximum18
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum16.3
5-th percentile17
Q117.2
Median17.3
Q317.5
95-th percentile17.9
Maximum18
Range1.7
Interquartile range0.3

Descriptive statistics

Standard deviation0.2818942801
Coef of variation0.0162453193
Kurtosis0.251354402
Mean17.35233853
MAD0.2217250906
Skewness0.6394780644
Sum7791.2
Variance0.07946438514
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%) 
17.2 122 25.2%
 
17.3 108 22.3%
 
17.1 55 11.4%
 
17.8 35 7.2%
 
17.4 24 5.0%
 
17.7 23 4.8%
 
17.9 22 4.5%
 
17 17 3.5%
 
17.6 14 2.9%
 
18 13 2.7%
 
Other values (7) 16 3.3%
 
(Missing) 35 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
16.3 1 0.2%
 
16.5 1 0.2%
 
16.6 1 0.2%
 
16.7 1 0.2%
 
16.8 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
18 13 2.7%
 
17.9 22 4.5%
 
17.8 35 7.2%
 
17.7 23 4.8%
 
17.6 14 2.9%
 

Cold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_Concentration
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

Cold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilStirringDuration(min)
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

Cold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilStirringDurationTxT
Categorical

Distinct count4
Unique (%)0.8%
Missing (%)52.7%
Missing (n)255
00:50:20
224
00:50:19
 
3
00:50:21
 
2
(Missing)
255
ValueCountFrequency (%) 
00:50:20 224 46.3%
 
00:50:19 3 0.6%
 
00:50:21 2 0.4%
 
(Missing) 255 52.7%
 
Max length8
Mean length5.365702479
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilSuspTemp(°C)
Numeric

Distinct count10
Unique (%)2.1%
Missing (%)98.1%
Missing (n)475
Infinite (%)0.0%
Infinite (n)0
Mean4.013075511
Minimum3.932063341
Maximum4.137290955
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum3.932063341
5-th percentile3.937540865
Q13.970867395
Median3.995992899
Q34.022171497
95-th percentile4.12474041
Maximum4.137290955
Range0.2052276134
Interquartile range0.05130410194

Descriptive statistics

Standard deviation0.06875574005
Coef of variation0.01713292956
Kurtosis-0.02296777838
Mean4.013075511
MAD0.05112718653
Skewness0.8847465536
Sum36.1176796
Variance0.004727351789
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3.995992899 1 0.2%
 
4.022171497 1 0.2%
 
4.016997337 1 0.2%
 
3.945757151 1 0.2%
 
3.932063341 1 0.2%
 
3.990624428 1 0.2%
 
4.137290955 1 0.2%
 
4.105914593 1 0.2%
 
3.970867395 1 0.2%
 
(Missing) 475 98.1%
 

Minimum 5 values

ValueCountFrequency (%) 
3.932063341 1 0.2%
 
3.945757151 1 0.2%
 
3.970867395 1 0.2%
 
3.990624428 1 0.2%
 
3.995992899 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
4.137290955 1 0.2%
 
4.105914593 1 0.2%
 
4.022171497 1 0.2%
 
4.016997337 1 0.2%
 
3.995992899 1 0.2%
 

Cold_Frac.7-FST_Filtration.Aerosil_Addition.Extract_Aging_(min)(min)
Numeric

Distinct count421
Unique (%)87.0%
Missing (%)7.2%
Missing (n)35
Infinite (%)0.0%
Infinite (n)0
Mean143.5813289
Minimum111.8
Maximum332.1666667
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum111.8
5-th percentile120.85
Q1129.35
Median138.5
Q3154.8333333
95-th percentile175.4666667
Maximum332.1666667
Range220.3666667
Interquartile range25.48333333

Descriptive statistics

Standard deviation20.91200819
Coef of variation0.1456457351
Kurtosis16.28913946
Mean143.5813289
MAD14.88031838
Skewness2.687322216
Sum64468.01667
Variance437.3120867
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
124.9833333 3 0.6%
 
136.7 3 0.6%
 
130.0166667 2 0.4%
 
137.4166667 2 0.4%
 
137.25 2 0.4%
 
147.4666667 2 0.4%
 
135.0833333 2 0.4%
 
141.8166667 2 0.4%
 
125.1666667 2 0.4%
 
146.5333333 2 0.4%
 
Other values (410) 427 88.2%
 
(Missing) 35 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
111.8 1 0.2%
 
113.45 1 0.2%
 
115.0166667 1 0.2%
 
115.1 1 0.2%
 
117.6333333 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
332.1666667 1 0.2%
 
245.7833333 1 0.2%
 
227.25 1 0.2%
 
226.2166667 1 0.2%
 
212 1 0.2%
 

Cold_Frac.7-FST_Filtration.Aerosil_Addition.ExtractDuration(h)
Numeric

Distinct count447
Unique (%)92.4%
Missing (%)7.2%
Missing (n)35
Infinite (%)0.0%
Infinite (n)0
Mean7.822212942
Minimum3.6
Maximum45.93138889
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum3.6
5-th percentile3.851111111
Q14.466944444
Median6.442222222
Q310.18472222
95-th percentile15.10527778
Maximum45.93138889
Range42.33138889
Interquartile range5.717777778

Descriptive statistics

Standard deviation4.391968146
Coef of variation0.5614738666
Kurtosis16.93464858
Mean7.822212942
MAD3.310763359
Skewness2.741968099
Sum3512.173611
Variance19.2893842
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
4.047222222 2 0.4%
 
7.479166667 2 0.4%
 
3.921666667 2 0.4%
 
12.26805556 1 0.2%
 
4.514166667 1 0.2%
 
8.5725 1 0.2%
 
16.6675 1 0.2%
 
4.514444444 1 0.2%
 
7.958611111 1 0.2%
 
9.414444444 1 0.2%
 
Other values (436) 436 90.1%
 
(Missing) 35 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
3.6 1 0.2%
 
3.63 1 0.2%
 
3.682222222 1 0.2%
 
3.684722222 1 0.2%
 
3.701944444 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
45.93138889 1 0.2%
 
38.99972222 1 0.2%
 
18.57388889 1 0.2%
 
18.57083333 1 0.2%
 
18.17166667 1 0.2%
 

Cold_Frac.7-FST_Filtration.Amount_of_Celpure
Numeric

Distinct count62
Unique (%)12.8%
Missing (%)7.2%
Missing (n)35
Infinite (%)0.0%
Infinite (n)0
Mean87.8
Minimum79.8
Maximum91.2
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum79.8
5-th percentile81.5
Q183.1
Median89.6
Q390.1
95-th percentile90.5
Maximum91.2
Range11.4
Interquartile range7

Descriptive statistics

Standard deviation3.443096094
Coef of variation0.03921521747
Kurtosis-0.7059497299
Mean87.8
MAD2.975055679
Skewness-1.071599791
Sum39422.2
Variance11.85491071
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
90.1 30 6.2%
 
89.9 27 5.6%
 
89.7 26 5.4%
 
89.8 26 5.4%
 
90 24 5.0%
 
89.4 21 4.3%
 
90.4 20 4.1%
 
90.3 20 4.1%
 
89.5 19 3.9%
 
89.6 18 3.7%
 
Other values (51) 218 45.0%
 
(Missing) 35 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
79.8 1 0.2%
 
80.5 1 0.2%
 
80.6 1 0.2%
 
80.7 2 0.4%
 
80.8 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
91.2 1 0.2%
 
91 1 0.2%
 
90.8 6 1.2%
 
90.7 7 1.4%
 
90.6 6 1.2%
 

Cold_Frac.7-FST_Filtration.Calcs.AerosilAmount/CPPWt
Numeric

Distinct count419
Unique (%)86.6%
Missing (%)7.2%
Missing (n)35
Infinite (%)0.0%
Infinite (n)0
Mean0.002317583158
Minimum0.002159321505
Maximum0.002543558438
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.002159321505
5-th percentile0.002238032797
Q10.002241392791
Median0.0022459657
Q30.002499541045
95-th percentile0.002541180497
Maximum0.002543558438
Range0.0003842369335
Interquartile range0.0002581482537

Descriptive statistics

Standard deviation0.0001274732339
Coef of variation0.05500265806
Kurtosis-0.7335388112
Mean0.002317583158
MAD0.0001109446406
Skewness1.116409976
Sum1.040594838
Variance1.624942537e-08
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.002241451209 2 0.4%
 
0.002248973012 2 0.4%
 
0.002247366165 2 0.4%
 
0.0022459657 2 0.4%
 
0.002543480732 2 0.4%
 
0.002237835025 2 0.4%
 
0.002239656324 2 0.4%
 
0.002243790148 2 0.4%
 
0.002248550277 2 0.4%
 
0.002249248071 2 0.4%
 
Other values (408) 429 88.6%
 
(Missing) 35 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0.002159321505 1 0.2%
 
0.002191838299 1 0.2%
 
0.002204671309 1 0.2%
 
0.00221475286 1 0.2%
 
0.002217556751 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
0.002543558438 1 0.2%
 
0.002543480732 2 0.4%
 
0.002543336175 1 0.2%
 
0.002543307223 1 0.2%
 
0.002543227768 1 0.2%
 

Cold_Frac.7-FST_Filtration.Calcs.AerosilMixDur(hours)
Highly correlated

This variable is highly correlated with Cold_Frac.7-FST_Filtration.Aerosil_Addition.Extract_Aging_(min)(min) and should be ignored for analysis

Correlation1

Cold_Frac.7-FST_Filtration.Calcs.CelpureAmount/CPPWt
Numeric

Distinct count419
Unique (%)86.6%
Missing (%)7.2%
Missing (n)35
Infinite (%)0.0%
Infinite (n)0
Mean0.0117019067
Minimum0.01126489412
Maximum0.01171402983
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.01126489412
5-th percentile0.0117010915
Q10.01170383307
Median0.01170706697
Q30.01171017955
95-th percentile0.01171322353
Maximum0.01171402983
Range0.0004491357101
Interquartile range6.346476935e-06

Descriptive statistics

Standard deviation3.47559005e-05
Coef of variation0.002970105761
Kurtosis71.70265035
Mean0.0117019067
MAD1.039559542e-05
Skewness-7.721395248
Sum5.254156109
Variance1.20797262e-09
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.01171131224 2 0.4%
 
0.0117034266 2 0.4%
 
0.01171297377 2 0.4%
 
0.01170383307 2 0.4%
 
0.01170407098 2 0.4%
 
0.01170322295 2 0.4%
 
0.01170999844 2 0.4%
 
0.01170938835 2 0.4%
 
0.01171217047 2 0.4%
 
0.01171285945 2 0.4%
 
Other values (408) 429 88.6%
 
(Missing) 35 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0.01126489412 1 0.2%
 
0.0114680111 1 0.2%
 
0.01149212498 1 0.2%
 
0.01149885011 1 0.2%
 
0.01150918617 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
0.01171402983 1 0.2%
 
0.01171391567 1 0.2%
 
0.0117138633 1 0.2%
 
0.01171383648 2 0.4%
 
0.01171377642 1 0.2%
 

Cold_Frac.7-FST_Filtration.Calcs.ExtractDur(hours)
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

Cold_Frac.7-FST_Filtration.Calcs.FRII+III_ExtractFiltrateStepRecovery
Highly correlated

This variable is highly correlated with Cold_Frac.7-FST_Filtration.Calcs.AerosilAmount/CPPWt and should be ignored for analysis

Correlation0.9530183949

Cold_Frac.7-FST_Filtration.Calcs.FRII+III_ExtractPasteRecovery
Numeric

Distinct count450
Unique (%)93.0%
Missing (%)7.2%
Missing (n)35
Infinite (%)0.0%
Infinite (n)0
Mean87.90196535
Minimum0
Maximum96.11693592
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile83.78127351
Q186.63908845
Median88.00780192
Q389.44717043
95-th percentile92.09185995
Maximum96.11693592
Range96.11693592
Interquartile range2.80808198

Descriptive statistics

Standard deviation4.799371254
Coef of variation0.05459913479
Kurtosis251.7683164
Mean87.90196535
MAD2.045767614
Skewness-13.75870197
Sum39467.98244
Variance23.03396443
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
87.7055189 1 0.2%
 
83.21762714 1 0.2%
 
87.87562 1 0.2%
 
87.35344164 1 0.2%
 
90.2676014 1 0.2%
 
89.602731 1 0.2%
 
88.52542661 1 0.2%
 
91.05229994 1 0.2%
 
88.49022904 1 0.2%
 
88.32619913 1 0.2%
 
Other values (439) 439 90.7%
 
(Missing) 35 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
79.54831613 1 0.2%
 
79.93512812 1 0.2%
 
81.21674126 1 0.2%
 
81.60545935 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
96.11693592 1 0.2%
 
94.53811686 1 0.2%
 
94.11612596 1 0.2%
 
94.10553999 1 0.2%
 
93.85888897 1 0.2%
 

Cold_Frac.7-FST_Filtration.Celpure_Addition_Duration
Numeric

Distinct count10
Unique (%)2.1%
Missing (%)98.1%
Missing (n)475
Infinite (%)0.0%
Infinite (n)0
Mean209.0851852
Minimum183.7333333
Maximum245.8
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum183.7333333
5-th percentile187.1333333
Q1195.6166667
Median207.2666667
Q3218.2666667
95-th percentile237.1466667
Maximum245.8
Range62.06666667
Interquartile range22.65

Descriptive statistics

Standard deviation18.68238075
Coef of variation0.08935296266
Kurtosis0.7120149882
Mean209.0851852
MAD13.77242798
Skewness0.7412939932
Sum1881.766667
Variance349.0313503
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
224.1666667 1 0.2%
 
210.0833333 1 0.2%
 
183.7333333 1 0.2%
 
207.2666667 1 0.2%
 
245.8 1 0.2%
 
218.2666667 1 0.2%
 
192.2333333 1 0.2%
 
204.6 1 0.2%
 
195.6166667 1 0.2%
 
(Missing) 475 98.1%
 

Minimum 5 values

ValueCountFrequency (%) 
183.7333333 1 0.2%
 
192.2333333 1 0.2%
 
195.6166667 1 0.2%
 
204.6 1 0.2%
 
207.2666667 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
245.8 1 0.2%
 
224.1666667 1 0.2%
 
218.2666667 1 0.2%
 
210.0833333 1 0.2%
 
207.2666667 1 0.2%
 

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.Celpure_Addition_End_Time
Categorical

Distinct count10
Unique (%)2.1%
Missing (%)98.1%
Missing (n)475
26-Dec-2018 04:06:05 AM
 
1
29-Dec-2018 03:14:00 AM
 
1
27-Dec-2018 09:21:53 AM
 
1
Other values (6)
 
6
(Missing)
475
ValueCountFrequency (%) 
26-Dec-2018 04:06:05 AM 1 0.2%
 
29-Dec-2018 03:14:00 AM 1 0.2%
 
27-Dec-2018 09:21:53 AM 1 0.2%
 
24-Dec-2018 05:50:32 PM 1 0.2%
 
30-Dec-2018 10:32:14 PM 1 0.2%
 
27-Dec-2018 10:48:55 PM 1 0.2%
 
28-Dec-2018 11:07:31 AM 1 0.2%
 
23-Dec-2018 07:56:25 AM 1 0.2%
 
29-Dec-2018 05:52:34 PM 1 0.2%
 
(Missing) 475 98.1%
 
Max length23
Mean length3.371900826
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.Celpure_Addition_Start_Time
Categorical

Distinct count10
Unique (%)2.1%
Missing (%)98.1%
Missing (n)475
29-Dec-2018 03:03:49 AM
 
1
28-Dec-2018 10:57:23 AM
 
1
27-Dec-2018 09:11:44 AM
 
1
Other values (6)
 
6
(Missing)
475
ValueCountFrequency (%) 
29-Dec-2018 03:03:49 AM 1 0.2%
 
28-Dec-2018 10:57:23 AM 1 0.2%
 
27-Dec-2018 09:11:44 AM 1 0.2%
 
30-Dec-2018 10:22:06 PM 1 0.2%
 
23-Dec-2018 07:46:17 AM 1 0.2%
 
24-Dec-2018 05:40:23 PM 1 0.2%
 
29-Dec-2018 05:42:25 PM 1 0.2%
 
27-Dec-2018 10:38:44 PM 1 0.2%
 
26-Dec-2018 03:55:57 AM 1 0.2%
 
(Missing) 475 98.1%
 
Max length23
Mean length3.371900826
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.End_of_Aerosil_Add_to_Start_of_Filt
Highly correlated

This variable is highly correlated with Cold_Frac.7-FST_Filtration.Calcs.AerosilMixDur(hours) and should be ignored for analysis

Correlation1

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.End_of_Aerosil_Add_to_Start_of_PreCond
Highly correlated

This variable is highly correlated with Cold_Frac.7-FST_Filtration.Dates_for_Calcs.End_of_Aerosil_Add_to_Start_of_Filt and should be ignored for analysis

Correlation0.9224255422

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_Aerosil_ADD_End
Categorical

Distinct count450
Unique (%)93.0%
Missing (%)7.2%
Missing (n)35
29-Aug-2019 05:49:25 PM
 
1
20-May-2019 02:12:25 PM
 
1
28-Mar-2019 01:06:10 AM
 
1
Other values (446)
446
(Missing)
 
35
ValueCountFrequency (%) 
29-Aug-2019 05:49:25 PM 1 0.2%
 
20-May-2019 02:12:25 PM 1 0.2%
 
28-Mar-2019 01:06:10 AM 1 0.2%
 
29-Sep-2019 06:10:46 AM 1 0.2%
 
27-Jun-2019 09:21:17 PM 1 0.2%
 
25-Aug-2019 05:12:20 PM 1 0.2%
 
19-Apr-2019 02:23:55 PM 1 0.2%
 
16-Feb-2019 03:47:12 AM 1 0.2%
 
12-Mar-2019 01:46:40 PM 1 0.2%
 
17-Apr-2019 02:57:12 PM 1 0.2%
 
Other values (439) 439 90.7%
 
(Missing) 35 7.2%
 
Max length23
Mean length21.55371901
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_FILT_End
Categorical

Distinct count450
Unique (%)93.0%
Missing (%)7.2%
Missing (n)35
06-Sep-2019 05:29:02 PM
 
1
30-Apr-2019 03:36:29 PM
 
1
06-Mar-2019 01:40:31 PM
 
1
Other values (446)
446
(Missing)
 
35
ValueCountFrequency (%) 
06-Sep-2019 05:29:02 PM 1 0.2%
 
30-Apr-2019 03:36:29 PM 1 0.2%
 
06-Mar-2019 01:40:31 PM 1 0.2%
 
12-Mar-2019 03:36:12 AM 1 0.2%
 
02-Sep-2019 01:15:10 AM 1 0.2%
 
13-Jul-2019 04:01:16 PM 1 0.2%
 
06-Oct-2019 06:39:03 PM 1 0.2%
 
02-Jun-2019 07:03:10 PM 1 0.2%
 
03-Jan-2019 11:01:42 PM 1 0.2%
 
20-Feb-2019 06:29:15 AM 1 0.2%
 
Other values (439) 439 90.7%
 
(Missing) 35 7.2%
 
Max length23
Mean length21.55371901
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_FILT_Start
Categorical

Distinct count450
Unique (%)93.0%
Missing (%)7.2%
Missing (n)35
10-Mar-2019 09:07:00 PM
 
1
27-Jan-2019 09:59:01 AM
 
1
12-May-2019 12:56:55 PM
 
1
Other values (446)
446
(Missing)
 
35
ValueCountFrequency (%) 
10-Mar-2019 09:07:00 PM 1 0.2%
 
27-Jan-2019 09:59:01 AM 1 0.2%
 
12-May-2019 12:56:55 PM 1 0.2%
 
04-Sep-2019 10:21:07 PM 1 0.2%
 
03-May-2019 06:40:20 AM 1 0.2%
 
04-Jan-2019 11:34:59 AM 1 0.2%
 
18-Feb-2019 01:04:31 AM 1 0.2%
 
27-Apr-2019 01:23:46 AM 1 0.2%
 
14-Sep-2019 09:13:08 PM 1 0.2%
 
18-Mar-2019 10:56:44 PM 1 0.2%
 
Other values (439) 439 90.7%
 
(Missing) 35 7.2%
 
Max length23
Mean length21.55371901
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_PRECOND_Start
Categorical

Distinct count450
Unique (%)93.0%
Missing (%)7.2%
Missing (n)35
09-Jun-2019 12:20:09 AM
 
1
31-May-2019 11:11:38 AM
 
1
26-Jan-2019 06:14:29 PM
 
1
Other values (446)
446
(Missing)
 
35
ValueCountFrequency (%) 
09-Jun-2019 12:20:09 AM 1 0.2%
 
31-May-2019 11:11:38 AM 1 0.2%
 
26-Jan-2019 06:14:29 PM 1 0.2%
 
08-May-2019 10:05:35 PM 1 0.2%
 
29-Mar-2019 08:04:40 PM 1 0.2%
 
08-Oct-2019 05:49:04 PM 1 0.2%
 
24-Jan-2019 07:46:34 AM 1 0.2%
 
25-Mar-2019 12:29:25 PM 1 0.2%
 
12-Sep-2019 07:21:31 PM 1 0.2%
 
23-Jul-2019 01:05:42 AM 1 0.2%
 
Other values (439) 439 90.7%
 
(Missing) 35 7.2%
 
Max length23
Mean length21.55371901
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_STIR_Start
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.Ext_Stir_Start_to_End_of_Aerosil_Add
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.Filtration_End_Time
Categorical

Distinct count10
Unique (%)2.1%
Missing (%)98.1%
Missing (n)475
27-Dec-2018 09:37:31 PM
 
1
27-Dec-2018 04:20:57 AM
 
1
22-Dec-2018 05:33:12 PM
 
1
Other values (6)
 
6
(Missing)
475
ValueCountFrequency (%) 
27-Dec-2018 09:37:31 PM 1 0.2%
 
27-Dec-2018 04:20:57 AM 1 0.2%
 
22-Dec-2018 05:33:12 PM 1 0.2%
 
25-Dec-2018 06:53:22 AM 1 0.2%
 
28-Dec-2018 12:01:43 PM 1 0.2%
 
29-Dec-2018 12:44:12 AM 1 0.2%
 
26-Dec-2018 01:12:34 PM 1 0.2%
 
24-Dec-2018 01:53:44 AM 1 0.2%
 
30-Dec-2018 07:49:59 AM 1 0.2%
 
(Missing) 475 98.1%
 
Max length23
Mean length3.371900826
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.Dates_for_Calcs.Filtration_Start_Time
Categorical

Distinct count10
Unique (%)2.1%
Missing (%)98.1%
Missing (n)475
25-Dec-2018 03:09:12 AM
 
1
28-Dec-2018 08:31:38 AM
 
1
28-Dec-2018 09:40:28 PM
 
1
Other values (6)
 
6
(Missing)
475
ValueCountFrequency (%) 
25-Dec-2018 03:09:12 AM 1 0.2%
 
28-Dec-2018 08:31:38 AM 1 0.2%
 
28-Dec-2018 09:40:28 PM 1 0.2%
 
27-Dec-2018 05:31:43 PM 1 0.2%
 
23-Dec-2018 10:38:07 PM 1 0.2%
 
22-Dec-2018 01:54:56 PM 1 0.2%
 
27-Dec-2018 01:08:43 AM 1 0.2%
 
30-Dec-2018 04:22:43 AM 1 0.2%
 
26-Dec-2018 09:47:58 AM 1 0.2%
 
(Missing) 475 98.1%
 
Max length23
Mean length3.371900826
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.FilterPressID
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

Cold_Frac.7-FST_Filtration.Filtrate_Amount(L)
Numeric

Distinct count272
Unique (%)56.2%
Missing (%)7.2%
Missing (n)35
Infinite (%)0.0%
Infinite (n)0
Mean8301.830735
Minimum7639
Maximum9596
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7639
5-th percentile8129.4
Q18197
Median8247
Q38368
95-th percentile8550.6
Maximum9596
Range1957
Interquartile range171

Descriptive statistics

Standard deviation214.1156602
Coef of variation0.02579137867
Kurtosis16.79441496
Mean8301.830735
MAD132.2739967
Skewness3.395500875
Sum3727522
Variance45845.51593
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
8199 5 1.0%
 
8186 5 1.0%
 
8264 5 1.0%
 
8259 4 0.8%
 
8295 4 0.8%
 
8242 4 0.8%
 
8229 4 0.8%
 
8258 4 0.8%
 
8230 4 0.8%
 
8228 4 0.8%
 
Other values (261) 406 83.9%
 
(Missing) 35 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
7639 1 0.2%
 
7856 1 0.2%
 
7975 1 0.2%
 
7977 1 0.2%
 
8012 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
9596 1 0.2%
 
9532 1 0.2%
 
9517 1 0.2%
 
9502 1 0.2%
 
9481 1 0.2%
 

Cold_Frac.7-FST_Filtration.Filtration_Duration
Numeric

Distinct count416
Unique (%)86.0%
Missing (%)7.2%
Missing (n)35
Infinite (%)0.0%
Infinite (n)0
Mean2.321620267
Minimum1.933333333
Maximum3.179722222
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.933333333
5-th percentile2.011833333
Q12.176388889
Median2.319166667
Q32.444444444
95-th percentile2.663333333
Maximum3.179722222
Range1.246388889
Interquartile range0.2680555556

Descriptive statistics

Standard deviation0.2050849885
Coef of variation0.08833700817
Kurtosis0.7120963398
Mean2.321620267
MAD0.1612287582
Skewness0.5566108199
Sum1042.4075
Variance0.04205985251
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
2.455 3 0.6%
 
1.993333333 3 0.6%
 
2.2525 2 0.4%
 
2.069166667 2 0.4%
 
2.436388889 2 0.4%
 
2.611944444 2 0.4%
 
2.250833333 2 0.4%
 
2.328611111 2 0.4%
 
2.265555556 2 0.4%
 
2.134722222 2 0.4%
 
Other values (405) 427 88.2%
 
(Missing) 35 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1.933333333 1 0.2%
 
1.946111111 1 0.2%
 
1.953888889 1 0.2%
 
1.954166667 1 0.2%
 
1.959444444 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
3.179722222 1 0.2%
 
3.086944444 1 0.2%
 
3.023333333 1 0.2%
 
2.940833333 1 0.2%
 
2.852222222 1 0.2%
 

Cold_Frac.7-FST_Filtration.FR_II+III_ExtractPasteWeight(kg)
Numeric

Distinct count405
Unique (%)83.7%
Missing (%)7.2%
Missing (n)35
Infinite (%)0.0%
Infinite (n)0
Mean659.1438713
Minimum0
Maximum727.1999
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile621.04006
Q1643.1001
Median666.4
Q3677.1001
95-th percentile691.46004
Maximum727.1999
Range727.1999
Interquartile range34

Descriptive statistics

Standard deviation38.68939369
Coef of variation0.05869643241
Kurtosis187.906004
Mean659.1438713
MAD20.611958
Skewness-11.15117416
Sum295955.5982
Variance1496.869184
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
676.6 3 0.6%
 
677.6 3 0.6%
 
683 3 0.6%
 
672.2 3 0.6%
 
673.7 3 0.6%
 
671.3 2 0.4%
 
658.4 2 0.4%
 
684.5 2 0.4%
 
664.6 2 0.4%
 
642.5001 2 0.4%
 
Other values (394) 424 87.6%
 
(Missing) 35 7.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
594.8 1 0.2%
 
595.8999 1 0.2%
 
598.9 1 0.2%
 
599 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
727.1999 1 0.2%
 
715.6 1 0.2%
 
709.8 1 0.2%
 
706.3001 1 0.2%
 
706.1 1 0.2%
 

Cold_Frac.7-FST_Filtration.Frac_II_+_III_Extract_Pre_Aerosil_Delivery_Sending_Tank_Temperature_during_Filtration
Numeric

Distinct count10
Unique (%)2.1%
Missing (%)98.1%
Missing (n)475
Infinite (%)0.0%
Infinite (n)0
Mean4.003214306
Minimum3.973361015
Maximum4.031047821
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum3.973361015
5-th percentile3.977115154
Q13.992337465
Median4.004617691
Q34.016435146
95-th percentile4.025737572
Maximum4.031047821
Range0.05768680573
Interquartile range0.02409768105

Descriptive statistics

Standard deviation0.01833325205
Coef of variation0.004579632926
Kurtosis-0.6220185201
Mean4.003214306
MAD0.01461109114
Skewness-0.2330060776
Sum36.02892876
Variance0.0003361081306
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
4.031047821 1 0.2%
 
4.017772198 1 0.2%
 
3.973361015 1 0.2%
 
3.998662472 1 0.2%
 
4.016435146 1 0.2%
 
4.004617691 1 0.2%
 
3.982746363 1 0.2%
 
3.992337465 1 0.2%
 
4.011948586 1 0.2%
 
(Missing) 475 98.1%
 

Minimum 5 values

ValueCountFrequency (%) 
3.973361015 1 0.2%
 
3.982746363 1 0.2%
 
3.992337465 1 0.2%
 
3.998662472 1 0.2%
 
4.004617691 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
4.031047821 1 0.2%
 
4.017772198 1 0.2%
 
4.016435146 1 0.2%
 
4.011948586 1 0.2%
 
4.004617691 1 0.2%
 

Cold_Frac.7-FST_Filtration.PostWashEndDT
Categorical

Distinct count450
Unique (%)93.0%
Missing (%)7.2%
Missing (n)35
29-Jun-2019 06:43:46 PM
 
1
22-Feb-2019 11:31:50 PM
 
1
28-May-2019 04:16:22 AM
 
1
Other values (446)
446
(Missing)
 
35
ValueCountFrequency (%) 
29-Jun-2019 06:43:46 PM 1 0.2%
 
22-Feb-2019 11:31:50 PM 1 0.2%
 
28-May-2019 04:16:22 AM 1 0.2%
 
09-Oct-2019 02:05:40 PM 1 0.2%
 
19-Jan-2019 07:54:57 AM 1 0.2%
 
07-Jun-2019 04:53:25 PM 1 0.2%
 
14-Jan-2019 05:20:43 PM 1 0.2%
 
22-Apr-2019 08:42:13 PM 1 0.2%
 
13-Apr-2019 10:57:26 AM 1 0.2%
 
08-Apr-2019 06:31:24 PM 1 0.2%
 
Other values (439) 439 90.7%
 
(Missing) 35 7.2%
 
Max length23
Mean length21.55371901
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.PPTG_Suspension_Post_Aging_Sending_Tank_Temperature_during_Filtration
Numeric

Distinct count10
Unique (%)2.1%
Missing (%)98.1%
Missing (n)475
Infinite (%)0.0%
Infinite (n)0
Mean-8.921274079
Minimum-9.070100784
Maximum-8.847999573
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-9.070100784
5-th percentile-9.058912659
Q1-9.031435013
Median-8.865652084
Q3-8.856654167
95-th percentile-8.848713684
Maximum-8.847999573
Range0.2221012115
Interquartile range0.1747808456

Descriptive statistics

Standard deviation0.09573980594
Coef of variation-0.01073162926
Kurtosis-1.521123739
Mean-8.921274079
MAD0.08440978439
Skewness-0.8795973909
Sum-80.29146671
Variance0.009166110441
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
-9.070100784 1 0.2%
 
-8.865652084 1 0.2%
 
-8.849784851 1 0.2%
 
-8.856982231 1 0.2%
 
-8.856654167 1 0.2%
 
-8.847999573 1 0.2%
 
-8.870727539 1 0.2%
 
-9.04213047 1 0.2%
 
-9.031435013 1 0.2%
 
(Missing) 475 98.1%
 

Minimum 5 values

ValueCountFrequency (%) 
-9.070100784 1 0.2%
 
-9.04213047 1 0.2%
 
-9.031435013 1 0.2%
 
-8.870727539 1 0.2%
 
-8.865652084 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
-8.847999573 1 0.2%
 
-8.849784851 1 0.2%
 
-8.856654167 1 0.2%
 
-8.856982231 1 0.2%
 
-8.865652084 1 0.2%
 

Cold_Frac.7-FST_Filtration.Sampling.IGG_Content(mg/mL)
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

Cold_Frac.7-FST_Filtration.Sampling.Tprotein(mg/mL)
Numeric

Distinct count132
Unique (%)27.3%
Missing (%)7.0%
Missing (n)34
Infinite (%)0.0%
Infinite (n)0
Mean5.452222222
Minimum4.62
Maximum6.43
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4.62
5-th percentile4.93
Q15.12
Median5.28
Q35.8975
95-th percentile6.26
Maximum6.43
Range1.81
Interquartile range0.7775

Descriptive statistics

Standard deviation0.4488410659
Coef of variation0.08232259207
Kurtosis-0.8951776316
Mean5.452222222
MAD0.3848444444
Skewness0.6808470208
Sum2453.5
Variance0.2014583024
Memory size3.9 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
5.26 11 2.3%
 
5.22 11 2.3%
 
5.2 10 2.1%
 
5.19 9 1.9%
 
5.13 9 1.9%
 
5.05 9 1.9%
 
5.28 9 1.9%
 
5.12 8 1.7%
 
5.31 8 1.7%
 
5.24 8 1.7%
 
Other values (121) 358 74.0%
 
(Missing) 34 7.0%
 

Minimum 5 values

ValueCountFrequency (%) 
4.62 1 0.2%
 
4.76 3 0.6%
 
4.8 1 0.2%
 
4.82 4 0.8%
 
4.83 2 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
6.43 1 0.2%
 
6.41 1 0.2%
 
6.4 1 0.2%
 
6.34 4 0.8%
 
6.33 3 0.6%
 

Cold_Frac.7-FST_Filtration.StartDT
Categorical

Distinct count450
Unique (%)93.0%
Missing (%)7.2%
Missing (n)35
10-Mar-2019 09:07:00 PM
 
1
27-Jan-2019 09:59:01 AM
 
1
12-May-2019 12:56:55 PM
 
1
Other values (446)
446
(Missing)
 
35
ValueCountFrequency (%) 
10-Mar-2019 09:07:00 PM 1 0.2%
 
27-Jan-2019 09:59:01 AM 1 0.2%
 
12-May-2019 12:56:55 PM 1 0.2%
 
04-Sep-2019 10:21:07 PM 1 0.2%
 
03-May-2019 06:40:20 AM 1 0.2%
 
04-Jan-2019 11:34:59 AM 1 0.2%
 
18-Feb-2019 01:04:31 AM 1 0.2%
 
27-Apr-2019 01:23:46 AM 1 0.2%
 
14-Sep-2019 09:13:08 PM 1 0.2%
 
18-Mar-2019 10:56:44 PM 1 0.2%
 
Other values (439) 439 90.7%
 
(Missing) 35 7.2%
 
Max length23
Mean length21.55371901
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Cold_Frac.7-FST_Filtration.SuspensionWeight
Highly correlated

This variable is highly correlated with Cold_Frac.7-FST_Filtration.Filtrate_Amount(L) and should be ignored for analysis

Correlation0.9745320981

df_index
Categorical, Unique

First 5 values
LB1899343
LB1899344
LB1899353
LB1899354
LB1899476
Last 5 values
LR1999456
LR1999458
LR1999470
LR1999472
LR1999474

First 5 values

ValueCountFrequency (%) 
LB1899343 1 0.2%
 
LB1899344 1 0.2%
 
LB1899353 1 0.2%
 
LB1899354 1 0.2%
 
LB1899476 1 0.2%
 

Last 5 values

ValueCountFrequency (%) 
LR1999474 1 0.2%
 
LR1999472 1 0.2%
 
LR1999470 1 0.2%
 
LR1999458 1 0.2%
 
LR1999456 1 0.2%
 

Parameter_Set_Date
Categorical

Distinct count266
Unique (%)55.0%
Missing (%)0.0%
Missing (n)0
01-Oct-2019 05:00:00 PM
 
11
17-Jan-2019 04:00:00 PM
 
10
11-Jan-2019 04:00:00 PM
 
9
Other values (263)
454
ValueCountFrequency (%) 
01-Oct-2019 05:00:00 PM 11 2.3%
 
17-Jan-2019 04:00:00 PM 10 2.1%
 
11-Jan-2019 04:00:00 PM 9 1.9%
 
07-Oct-2019 05:00:00 PM 8 1.7%
 
06-Sep-2019 05:00:00 PM 7 1.4%
 
02-Oct-2019 05:00:00 PM 6 1.2%
 
30-Sep-2019 05:00:00 PM 5 1.0%
 
08-Oct-2019 05:00:00 PM 5 1.0%
 
03-Oct-2019 05:00:00 PM 5 1.0%
 
12-Mar-2019 05:00:00 PM 4 0.8%
 
Other values (256) 414 85.5%
 
Max length23
Mean length23
Min length23
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Unnamed_1
Categorical

Distinct count266
Unique (%)55.0%
Missing (%)0.0%
Missing (n)0
01-Oct-2019 05:00:00 PM
 
11
17-Jan-2019 04:00:00 PM
 
10
11-Jan-2019 04:00:00 PM
 
9
Other values (263)
454
ValueCountFrequency (%) 
01-Oct-2019 05:00:00 PM 11 2.3%
 
17-Jan-2019 04:00:00 PM 10 2.1%
 
11-Jan-2019 04:00:00 PM 9 1.9%
 
07-Oct-2019 05:00:00 PM 8 1.7%
 
06-Sep-2019 05:00:00 PM 7 1.4%
 
02-Oct-2019 05:00:00 PM 6 1.2%
 
30-Sep-2019 05:00:00 PM 5 1.0%
 
08-Oct-2019 05:00:00 PM 5 1.0%
 
03-Oct-2019 05:00:00 PM 5 1.0%
 
12-Mar-2019 05:00:00 PM 4 0.8%
 
Other values (256) 414 85.5%
 
Max length23
Mean length23
Min length23
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Correlations

Missing values

Sample

First rows

Cold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_Addition_End_DTCold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_AmountCold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_ConcentrationCold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilStirringDuration(min)Cold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilStirringDurationTxTCold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilSuspTemp(°C)Cold_Frac.7-FST_Filtration.Aerosil_Addition.Extract_Aging_(min)(min)Cold_Frac.7-FST_Filtration.Aerosil_Addition.ExtractDuration(h)Cold_Frac.7-FST_Filtration.Amount_of_CelpureCold_Frac.7-FST_Filtration.Calcs.AerosilAmount/CPPWtCold_Frac.7-FST_Filtration.Calcs.AerosilMixDur(hours)Cold_Frac.7-FST_Filtration.Calcs.CelpureAmount/CPPWtCold_Frac.7-FST_Filtration.Calcs.ExtractDur(hours)Cold_Frac.7-FST_Filtration.Calcs.FRII+III_ExtractFiltrateStepRecoveryCold_Frac.7-FST_Filtration.Calcs.FRII+III_ExtractPasteRecoveryCold_Frac.7-FST_Filtration.Celpure_Addition_DurationCold_Frac.7-FST_Filtration.Dates_for_Calcs.Celpure_Addition_End_TimeCold_Frac.7-FST_Filtration.Dates_for_Calcs.Celpure_Addition_Start_TimeCold_Frac.7-FST_Filtration.Dates_for_Calcs.End_of_Aerosil_Add_to_Start_of_FiltCold_Frac.7-FST_Filtration.Dates_for_Calcs.End_of_Aerosil_Add_to_Start_of_PreCondCold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_Aerosil_ADD_EndCold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_FILT_EndCold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_FILT_StartCold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_PRECOND_StartCold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_STIR_StartCold_Frac.7-FST_Filtration.Dates_for_Calcs.Ext_Stir_Start_to_End_of_Aerosil_AddCold_Frac.7-FST_Filtration.Dates_for_Calcs.Filtration_End_TimeCold_Frac.7-FST_Filtration.Dates_for_Calcs.Filtration_Start_TimeCold_Frac.7-FST_Filtration.FilterPressIDCold_Frac.7-FST_Filtration.Filtrate_Amount(L)Cold_Frac.7-FST_Filtration.Filtration_DurationCold_Frac.7-FST_Filtration.FR_II+III_ExtractPasteWeight(kg)Cold_Frac.7-FST_Filtration.Frac_II_+_III_Extract_Pre_Aerosil_Delivery_Sending_Tank_Temperature_during_FiltrationCold_Frac.7-FST_Filtration.PostWashEndDTCold_Frac.7-FST_Filtration.PPTG_Suspension_Post_Aging_Sending_Tank_Temperature_during_FiltrationCold_Frac.7-FST_Filtration.Sampling.IGG_Content(mg/mL)Cold_Frac.7-FST_Filtration.Sampling.Tprotein(mg/mL)Cold_Frac.7-FST_Filtration.StartDTCold_Frac.7-FST_Filtration.SuspensionWeightdf_indexParameter_Set_DateUnnamed_1
005-Jan-2019 04:02:10 PM17.2NaNNaN00:50:20NaN135.0833336.63361189.70.0022462.2513890.011712NaN106.74274786.125388NaNNaNNaN2.2513891.91000005-Jan-2019 04:02:10 PM05-Jan-2019 08:55:30 PM05-Jan-2019 06:17:15 PM05-Jan-2019 05:56:46 PMNaNNaNNaNNaNNaN8175.02.637500659.5999NaN05-Jan-2019 08:55:34 PMNaNNaN5.1305-Jan-2019 06:17:15 PM7220.6LB199900301-Jan-2019 04:00:00 PM01-Jan-2019 04:00:00 PM
106-Jan-2019 06:32:05 AM17.7NaNNaNNaNNaN157.2333336.62722281.70.0025352.6205560.011700NaN120.39583091.052300NaNNaNNaN2.6205562.13555606-Jan-2019 06:32:05 AM06-Jan-2019 11:10:56 AM06-Jan-2019 09:09:19 AM06-Jan-2019 08:40:13 AMNaNNaNNaNNaNNaN8407.02.026944635.8000NaN06-Jan-2019 11:11:00 AMNaNNaN6.3406-Jan-2019 09:09:19 AM7404.6LR199900401-Jan-2019 04:00:00 PM01-Jan-2019 04:00:00 PM
206-Jan-2019 06:54:01 PM17.1NaNNaN00:50:20NaN133.7333334.96527889.50.0022382.2288890.011714NaN106.8240710.000000NaNNaNNaN2.2288891.88305606-Jan-2019 06:54:01 PM06-Jan-2019 11:32:52 PM06-Jan-2019 09:07:45 PM06-Jan-2019 08:47:00 PMNaNNaNNaNNaNNaN8162.02.4186110.0000NaN06-Jan-2019 11:32:56 PMNaNNaN5.2306-Jan-2019 09:07:45 PM7195.4LB199900502-Jan-2019 04:00:00 PM02-Jan-2019 04:00:00 PM
307-Jan-2019 02:28:18 PM17.9NaNNaNNaNNaN119.2333339.34444482.60.0025381.9872220.011711NaN120.78375292.540870NaNNaNNaN1.9872221.65444407-Jan-2019 02:28:18 PM07-Jan-2019 06:37:49 PM07-Jan-2019 04:27:32 PM07-Jan-2019 04:07:34 PMNaNNaNNaNNaNNaN8519.02.171389652.7001NaN07-Jan-2019 06:37:54 PMNaNNaN6.0907-Jan-2019 04:27:32 PM7482.8LR199900602-Jan-2019 04:00:00 PM02-Jan-2019 04:00:00 PM
408-Jan-2019 08:58:07 PM17.7NaNNaNNaNNaN180.4666679.64750081.80.0025333.0077780.011708NaN121.04600292.491341NaNNaNNaN3.0077782.53361108-Jan-2019 08:58:07 PM09-Jan-2019 01:59:53 AM08-Jan-2019 11:58:35 PM08-Jan-2019 11:30:08 PMNaNNaNNaNNaNNaN8457.02.021667646.2000NaN09-Jan-2019 01:59:57 AMNaNNaN6.2308-Jan-2019 11:58:35 PM7413.4LR199900804-Jan-2019 04:00:00 PM04-Jan-2019 04:00:00 PM
510-Jan-2019 05:33:24 PM17.1NaNNaN00:50:20NaN137.0000003.71416789.10.0022472.2833330.011710NaN106.21771987.989052NaNNaNNaN2.2833331.69777810-Jan-2019 05:33:24 PM10-Jan-2019 10:16:02 PM10-Jan-2019 07:50:24 PM10-Jan-2019 07:15:16 PMNaNNaNNaNNaNNaN8082.02.427222669.4999NaN10-Jan-2019 10:16:07 PMNaNNaN5.2010-Jan-2019 07:50:24 PM7120.3LB199901105-Jan-2019 04:00:00 PM05-Jan-2019 04:00:00 PM
610-Jan-2019 12:35:49 AM17.5NaNNaNNaNNaN129.3166676.83111180.80.0025352.1552780.011706NaN121.19322591.391137NaNNaNNaN2.1552781.71944410-Jan-2019 12:35:49 AM10-Jan-2019 04:44:44 AM10-Jan-2019 02:45:08 AM10-Jan-2019 02:18:59 AMNaNNaNNaNNaNNaN8365.01.993333630.8000NaN10-Jan-2019 04:44:48 AMNaNNaN6.2910-Jan-2019 02:45:08 AM7326.6LR199901005-Jan-2019 04:00:00 PM05-Jan-2019 04:00:00 PM
711-Jan-2019 07:17:23 AM17.7NaNNaNNaNNaN128.7666675.35777881.80.0025342.1461110.011712NaN120.95871896.116936NaNNaNNaN2.1461111.74388911-Jan-2019 07:17:23 AM11-Jan-2019 11:27:28 AM11-Jan-2019 09:26:09 AM11-Jan-2019 09:02:01 AMNaNNaNNaNNaNNaN8448.02.021944671.3000NaN11-Jan-2019 11:27:32 AMNaNNaN6.2511-Jan-2019 09:26:09 AM7399.1LR199901206-Jan-2019 04:00:00 PM06-Jan-2019 04:00:00 PM
811-Jan-2019 09:17:03 PM17.2NaNNaN00:50:20NaN143.9500005.92694489.70.0022442.3991670.011703NaN106.68667288.251027NaNNaNNaN2.3991671.86833311-Jan-2019 09:17:03 PM12-Jan-2019 01:54:10 AM11-Jan-2019 11:41:00 PM11-Jan-2019 11:09:09 PMNaNNaNNaNNaNNaN8177.02.219444676.4000NaN12-Jan-2019 01:54:14 AMNaNNaN5.2511-Jan-2019 11:41:00 PM7176.9LB199901307-Jan-2019 04:00:00 PM07-Jan-2019 04:00:00 PM
913-Jan-2019 03:55:51 AM17.3NaNNaN00:50:20NaN125.5666674.46388990.50.0022392.0927780.011711NaN106.47135787.319970NaNNaNNaN2.0927781.62333313-Jan-2019 03:55:51 AM13-Jan-2019 08:25:01 AM13-Jan-2019 06:01:25 AM13-Jan-2019 05:33:15 AMNaNNaNNaNNaNNaN8228.02.393333674.8000NaN13-Jan-2019 08:25:05 AMNaNNaN5.3313-Jan-2019 06:01:25 AM7256.1LB199901708-Jan-2019 04:00:00 PM08-Jan-2019 04:00:00 PM

Last rows

Cold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_Addition_End_DTCold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_AmountCold_Frac.7-FST_Filtration.Aerosil_Addition.Aerosil_ConcentrationCold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilStirringDuration(min)Cold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilStirringDurationTxTCold_Frac.7-FST_Filtration.Aerosil_Addition.AerosilSuspTemp(°C)Cold_Frac.7-FST_Filtration.Aerosil_Addition.Extract_Aging_(min)(min)Cold_Frac.7-FST_Filtration.Aerosil_Addition.ExtractDuration(h)Cold_Frac.7-FST_Filtration.Amount_of_CelpureCold_Frac.7-FST_Filtration.Calcs.AerosilAmount/CPPWtCold_Frac.7-FST_Filtration.Calcs.AerosilMixDur(hours)Cold_Frac.7-FST_Filtration.Calcs.CelpureAmount/CPPWtCold_Frac.7-FST_Filtration.Calcs.ExtractDur(hours)Cold_Frac.7-FST_Filtration.Calcs.FRII+III_ExtractFiltrateStepRecoveryCold_Frac.7-FST_Filtration.Calcs.FRII+III_ExtractPasteRecoveryCold_Frac.7-FST_Filtration.Celpure_Addition_DurationCold_Frac.7-FST_Filtration.Dates_for_Calcs.Celpure_Addition_End_TimeCold_Frac.7-FST_Filtration.Dates_for_Calcs.Celpure_Addition_Start_TimeCold_Frac.7-FST_Filtration.Dates_for_Calcs.End_of_Aerosil_Add_to_Start_of_FiltCold_Frac.7-FST_Filtration.Dates_for_Calcs.End_of_Aerosil_Add_to_Start_of_PreCondCold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_Aerosil_ADD_EndCold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_FILT_EndCold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_FILT_StartCold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_FP_PRECOND_StartCold_Frac.7-FST_Filtration.Dates_for_Calcs.EXT_STIR_StartCold_Frac.7-FST_Filtration.Dates_for_Calcs.Ext_Stir_Start_to_End_of_Aerosil_AddCold_Frac.7-FST_Filtration.Dates_for_Calcs.Filtration_End_TimeCold_Frac.7-FST_Filtration.Dates_for_Calcs.Filtration_Start_TimeCold_Frac.7-FST_Filtration.FilterPressIDCold_Frac.7-FST_Filtration.Filtrate_Amount(L)Cold_Frac.7-FST_Filtration.Filtration_DurationCold_Frac.7-FST_Filtration.FR_II+III_ExtractPasteWeight(kg)Cold_Frac.7-FST_Filtration.Frac_II_+_III_Extract_Pre_Aerosil_Delivery_Sending_Tank_Temperature_during_FiltrationCold_Frac.7-FST_Filtration.PostWashEndDTCold_Frac.7-FST_Filtration.PPTG_Suspension_Post_Aging_Sending_Tank_Temperature_during_FiltrationCold_Frac.7-FST_Filtration.Sampling.IGG_Content(mg/mL)Cold_Frac.7-FST_Filtration.Sampling.Tprotein(mg/mL)Cold_Frac.7-FST_Filtration.StartDTCold_Frac.7-FST_Filtration.SuspensionWeightdf_indexParameter_Set_DateUnnamed_1
474NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNLR199947207-Oct-2019 05:00:00 PM07-Oct-2019 05:00:00 PM
475NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNLB199947508-Oct-2019 05:00:00 PM08-Oct-2019 05:00:00 PM
476NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNLB199947608-Oct-2019 05:00:00 PM08-Oct-2019 05:00:00 PM
477NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNLB199947708-Oct-2019 05:00:00 PM08-Oct-2019 05:00:00 PM
478NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNLB199947808-Oct-2019 05:00:00 PM08-Oct-2019 05:00:00 PM
479NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNLR199947408-Oct-2019 05:00:00 PM08-Oct-2019 05:00:00 PM
480NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNLB199945713-Oct-2019 05:00:00 PM13-Oct-2019 05:00:00 PM
481NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNLB199945913-Oct-2019 05:00:00 PM13-Oct-2019 05:00:00 PM
482NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNLR199942713-Oct-2019 05:00:00 PM13-Oct-2019 05:00:00 PM
483NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNLR199945813-Oct-2019 05:00:00 PM13-Oct-2019 05:00:00 PM